﻿<%@ Page Title="" Language="C#" MasterPageFile="~/design_page/admin/admin.master" AutoEventWireup="true" CodeFile="admin_member_show_all.aspx.cs" Inherits="design_page_admin_Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div style="text-align: center; margin-right: auto; margin-left: auto; height: 166px;">
          <div style="text-align: center; margin-right: auto; margin-left: auto; width: 698px;" >
        <table cellpadding="0" cellspacing="11" class="style19" style="width: 697px">
            <tr>
                  <td style="width: 55px">
                      &nbsp;</td>
                  <td>
                      <asp:GridView ID="GridView_admin" runat="server" AutoGenerateColumns="False" 
                          CellPadding="4" DataKeyNames="column1" DataSourceID="SqlDataSource4" 
                          ForeColor="#333333" GridLines="None" onrowcommand="GridView_admin_Command" 
                          Width="608px" AllowPaging="True" PageSize="15">
                          <AlternatingRowStyle BackColor="White" />
                          <Columns>
                              <asp:BoundField DataField="column1" HeaderText="管理员ID" ReadOnly="True" 
                                  SortExpression="column1" />
                              <asp:BoundField DataField="column2" HeaderText="姓名" 
                                  SortExpression="column2" />
                              <asp:BoundField DataField="column3" HeaderText="性别" SortExpression="column3" />
                              <asp:BoundField DataField="column4" HeaderText="电话" 
                                  SortExpression="column4" />
                              <asp:ButtonField CommandName="delete_row" Text="删除" />
                          </Columns>
                          <EditRowStyle BackColor="#2461BF" />
                          <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                          <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                          <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                          <RowStyle BackColor="#EFF3FB" />
                          <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                          <SortedAscendingCellStyle BackColor="#F5F7FB" />
                          <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                          <SortedDescendingCellStyle BackColor="#E9EBEF" />
                          <SortedDescendingHeaderStyle BackColor="#4870BE" />
                      </asp:GridView>
                      <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                          ConnectionString="<%$ ConnectionStrings:mei_design_5.2 %>" 
                          
                          SelectCommand="SELECT [_Aid] AS column1, [_Aname] AS column2, [_Asex] AS column3, [_Aphone] AS column4 FROM [_admin]">
                      </asp:SqlDataSource>
                      <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                          ConnectionString="<%$ ConnectionStrings:mei_design_Connection_class_all_str %>" 
                          
                          SelectCommand="SELECT [_Sid] AS column1, [_Sname] AS column2, [_Ssex] AS column3, [_Sphone] AS column4, [_SCid] AS column5 FROM [_student]">
                      </asp:SqlDataSource>
                      <asp:SqlDataSource ID="member_all" runat="server" 
                          ConnectionString="<%$ ConnectionStrings:mei_design_member %>" 
                          SelectCommand="SELECT * FROM [_admin]"></asp:SqlDataSource>
                 </td>
            </tr>
                                 
            <tr>
                  <td style="width: 55px">
                      &nbsp;</td>
                  <td>
                   <asp:GridView ID="GridView_teacher" runat="server" AutoGenerateColumns="False" 
                          CellPadding="4" DataKeyNames="column1" DataSourceID="SqlDataSource3" 
                          ForeColor="#333333" GridLines="None" 
                          onrowcommand="GridView_teacher_Command" Width="608px" AllowPaging="True" 
                          PageSize="15">
                          <AlternatingRowStyle BackColor="White" />
                          <Columns>
                              <asp:BoundField DataField="column1" HeaderText="教师ID" ReadOnly="True" 
                                  SortExpression="column1" />
                              <asp:BoundField DataField="column2" HeaderText="姓名" 
                                  SortExpression="column2" />
                              <asp:BoundField DataField="column3" HeaderText="性别" SortExpression="column3" />
                              <asp:BoundField DataField="column4" HeaderText="电话" 
                                  SortExpression="column4" />
                              <asp:ButtonField CommandName="teacher_delete" Text="删除" />
                          </Columns>
                          <EditRowStyle BackColor="#2461BF" />
                          <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                          <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                          <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                          <RowStyle BackColor="#EFF3FB" />
                          <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                          <SortedAscendingCellStyle BackColor="#F5F7FB" />
                          <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                          <SortedDescendingCellStyle BackColor="#E9EBEF" />
                          <SortedDescendingHeaderStyle BackColor="#4870BE" />
                      </asp:GridView>
                      <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                          ConnectionString="<%$ ConnectionStrings:mei_design_5.2 %>" 
                          
                          SelectCommand="SELECT [_Tid] AS column1, [_Tname] AS column2, [_Tsex] AS column3, [_Tphone] AS column4 FROM [_teacher]">
                      </asp:SqlDataSource>
                     
                 </td>
            </tr>
                                 
            <tr>
                  <td style="width: 55px">
                      &nbsp;</td>
                  <td>
                     <asp:GridView ID="GridView_student" runat="server" AutoGenerateColumns="False" 
                          CellPadding="4" DataKeyNames="column1" DataSourceID="SqlDataSource2" 
                          ForeColor="#333333" GridLines="None" 
                          onrowcommand="GridView_student_Command" Width="608px" AllowPaging="True" 
                          PageSize="16">
                          <AlternatingRowStyle BackColor="White" />
                          <Columns>
                              <asp:BoundField DataField="column1" HeaderText="学生ID" ReadOnly="True" 
                                  SortExpression="column1" />
                              <asp:BoundField DataField="column5" HeaderText="姓名" 
                                  SortExpression="column5" />
                              <asp:BoundField DataField="column4" HeaderText="性别" SortExpression="column4" />
                              <asp:BoundField DataField="column2" HeaderText="电话" 
                                  SortExpression="column2" />
                              <asp:BoundField DataField="column3" HeaderText="班级" SortExpression="column3" />
                              <asp:ButtonField CommandName="student_delete" Text="删除" />
                          </Columns>
                          <EditRowStyle BackColor="#2461BF" />
                          <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                          <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                          <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                          <RowStyle BackColor="#EFF3FB" />
                          <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                          <SortedAscendingCellStyle BackColor="#F5F7FB" />
                          <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                          <SortedDescendingCellStyle BackColor="#E9EBEF" />
                          <SortedDescendingHeaderStyle BackColor="#4870BE" />
                      </asp:GridView>
                      <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                          ConnectionString="<%$ ConnectionStrings:mei_design_5.2 %>" 
                          
                          SelectCommand="SELECT [_Sid] AS column1, [_Sphone] AS column2, [_SCid] AS column3, [_Ssex] AS column4, [_Sname] AS column5 FROM [_student]">
                      </asp:SqlDataSource>
                 </td>
            </tr>
                                 
        </table>
       </div> 
    </div>

</asp:Content>

